package com.trkj.dao.hjj;

//总事务类型确认

import java.util.List;

import org.springframework.data.domain.Pageable;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.CrudRepository;

import com.trkj.pojo.Affairtypeconfirm;

public interface AffairtypeconfirmDAO extends CrudRepository<Affairtypeconfirm, Long>{
	@Query("select a,s,af from Affairtypeconfirm a inner join a.staffInformation s inner join a.affaircategory af where af.affcaId=2")
	public List<Object[]> findAllAffairtype(Pageable p);
}
